package com.db.workreport;

import com.db.user.UserVO;
import com.db.workreport.*;


import com.ibatis.common.resources.*;

import com.ibatis.sqlmap.client.*;

import java.io.*;
import java.util.*;

import org.springframework.orm.ibatis.SqlMapClientTemplate;

public class WorkReportDAO {
	private SqlMapClientTemplate template;
	
	
	public void setTemplate(SqlMapClientTemplate template) {
		this.template = template;
	}
	
	
	public  List<WorkReportVO> reportAllData_get(int sabun) throws Exception{		
		return template.queryForList("reportAllData_get", sabun);
	}
	public  List<WorkReportVO> reportAllData_agreer(int sabun) throws Exception{
		return template.queryForList("reportAllData_agreer", sabun);
	}
	
	public  List<WorkReportVO> reportAllData_send(int sabun) throws Exception{
		return template.queryForList("reportAllData_send", sabun);
	}
	
	public  WorkReportVO callContentData(int no)throws Exception
	{
		return (WorkReportVO)template.queryForObject("callContentData",no);
	}
	public  void InsertData(WorkReportVO vo)throws Exception
	{

		template.insert("InsertData",vo);
	}
	public  void InsertData1(WorkReportVO vo)throws Exception
	{
	
		template.insert("InsertData1",vo);
	}
	
	
	
	public  List<UserVO> UserList(UserVO vo)throws Exception
	{
		
		return template.queryForList("userList",vo);
	}
	
	
	
	public  void firststep(int no)throws Exception
	{
		template.update("firststep",no);
	}
	
	
	public  void finalstep(int no)throws Exception
	{
		template.update("finalstep",no);
	}
	public  void backtothebottom(int no)throws Exception
	{
		template.update("backtothebottom",no);
	}
	public  void backtothemiddle(int no)throws Exception
	{
		template.update("backtothemiddle",no);
	}
}
